Shareware Super Platinum 8

home *** CD-ROM | disk | FTP | other *** search

/ Shareware Super Platinum 8 / Shareware Super Platinum 8.iso / mac / DATABASE / ESDV21.ZIP;1 / README.1ST < prev next >

Wrap

Text File | 1993-02-18 | 23.1 KB | 552 lines

_________________________________________________________________________ _____________________________________________________________________ | | | The ENSONIQ EPS Sample Database (ESD) v2.01 | ____|_________________________________________________________|______ _________________________________________________________________________ Written February 1993 by: Joe Santacroce DATA Solutions 9 Neversink Dr. Newburgh, NY 12550 [914]566-0890 (First version written in November of 1992) (See history at end of this file) _________________________________________________________________________ ======================================================================== First things first I guess.... As sort of a little payback for all I've gotten out of MIDILink, I offer this to any MIDILink user who might get some use out of it. You can freely distribute this program as long as all the files are distributed as is, with no modifications whatsoever. USE THIS AT YOUR OWN RISK.. I TAKE NO RESPONSIBILITY WHATSOEVER. FOR ESD or EDIR. I USE THIS ALL THE TIME. YOU SHOULD HAVE NO PROBLEMS EITHER. ESD is written in Clipper 5.01 using the DCLIP Library from Donnay Software Designs, Grumplib from Grumpfish Inc., Superlib from Functional Software and R&R Report Writer from Concentric Data. Each holds copyrights to their respective libraries and source code. They are used and distributed under royalty free runtime licensing agreements. ===================================================================== This is a free application to anyone who wants to use it, and I will try to make improvements and fixes where I can. But, this will depend on the mood I'm in, the mood the wife's in, time schedule and etc. etc. Thanks for the feedback from everyone so far. ===================================================================== ===================================================================== ===================================================================== Now using EDIR.EXE (Copyright and courtesy of Resident MIDILink Tech Wizard Mark Pulver aka JWalsh Toys) to read EPS Disks. EDIR appears to be incorporated directly into the application for a more seamless and easier to use approach. This utility is included in this package free of charge from JWalsh Toys. However, JWalsh Toys has total rights to the utility and may at any future time do with the program however they wish. I appreciate it being made available to be used and distributed with ESD. Thanks Mark... It's pretty much self explantory as is most of the rest of the program. After loading ESD just pop in an EPS disk in the A: or B: drive. Choose IMPORT and the appropriate drive. Press ENTER to Re-Read the disk, W to Write the info to a text file, or Q to Quit. Don't worry about pressing W)rite too many times because the import process automatically deletes any duplicate disk reads. If the disk already exists in your sample database, it will not be added. Numbers are automatically assigned to disks during IMPORT but you can edit the numbers afterwards. The idea here is to feed all your existing disks in at once and number them as you go along. Then as you add new sample disks, just read them in and they will be numbered beginning with the last number currently in the database + 1. The import process will automatically run if it finds that you Wrote out the disk info with the W)rite command. Upgrade Note: I would recommend that you create a new sample database and feed all your disks back into it if you are upgrading. The reason is because of EDIR. It can properly distinguish between instruments, sound banks and songs and and are now properly placed in the database and reported. ===================================================================== ===================================================================== ===================================================================== Ok, what is ESD? This program is for EPS Sampler users (and EPS 16+ of course) who have a collection of sample disks but no way to easily keep track of them. I, am (was) one of those users. I haven't tried it with MIRAGE samples, if EDIR reads them, it should work. Note: Once ASR-10 disks are released, If Mark Pulver (JWalsh Toys!) upgrades EDIR to read ASR-10 disks, then possibly only EDIR.EXE will be required to be upgraded. Features: -Reads Ensoniq EPS and EPS16+ (and rackmounts) Disks -Automatically Imports the disk information ** !! ** Now Includes Label Printing for EPS Disks ** !! ** -Menu Driven easy to use Browse/View/Edit/Search/Query/List -Reads ANY IBM file type in addition to ENSONIQ EPS Disks You determine what types of files are imported by adding that file types Extension to the Extensions Lookup Table. -Interactive Query/Filter for all functions Now has the ability to store queries that you create and use them anywhere throughout the application so you don't have to recreate a query when you go from Browse/Edit to List Mode and then to print reports. Once you create a set of standard queries you won't have to any more. -Several sorted 'Canned' Reports for both EPS and Non-EPS -Build your own quick reports/lists for all files -All reports print to both screen or printer (some to file too!) -Point and shoot index selection -Pop-up indexed key searches for instantly locating a sample -Pop-ups for Types, Qualities, Sources -New Help System throughout with help index (Press F1 twice) -Notepad / Text Editor -Easy to use -Free **!!** (but don't ask for much in the way of changes (g)) -Should run on just about anything. (If not, give a holler!) (might be a tad slow on SX and lower powered PC's) -Loves EMS memory if ya got it. Software caches such as Hyper Disk, PC-Kwik, SMARTDRV, NCACHE and others all work well the system. Just don't reboot with files open though or you'll probably have some corrupted data files. Actually, the cache will make a !!!!BIG!!!! difference in how the program performs and I recommend one highly. Even if you can spare just a meg or two, it will help alot. Motto -> Backup!!! I have tested it with various caches (smartdrv, hyperdisk, ncache, pckwik) and with QEMM and HIMEM. I have it loaded on my system now with QEMM and Stealth mode set ST:M and it's working fine (so far!). The program will run on just about anything. I have tested it in under 512k of memory and it runs, but it slows way down without some memory overhead. Better yet, throw it a meg or 2 of EMS and it will perk right up. As with the case of most Clipper programs, the .EXE is fairly large and on SX and/or 286 machines it will bogg down. A decent hard drive and a sofware cache help considerably also. The cheapest and quickest way to speed this thing up is to install a software cache like NCACHE, SMARTDRV, etc. etc. etc.... You can also PKLITE the program if you own PKLITE. I didn't ship it that way because A - I don't have PKLITE, B - if any upgrades of ESD are distributed (I kinda doubt it unless a major bug) I will probably just send out patch files which will be looking for an original ESD.EXE to update. (ex: pklite -a -e esd.exe) ======================================================================= FILES Use can create all new databases by just renaming or deleting SAMPLES.DBF. Keep in mind that once you do, you'll have to start over, copy over or append from a backup file. The files that must exist for the program to operate are as follows: ESD EXE - Main program file. A must have of course! EDIR EXE - The EPS PC Disk Read Util by JWalas Toys. A Must! ESD PIF - Default PIF file for running under Windows ESD ICO - Chintzy ICON I slapped together just to have something under Windows. SAMPLES DBF - Main datafile. Created automatically. SAMPLES DBT - The memo file for comments/note. Created automatically with SAMPLES.DBF. If damaged or deleted, the program will ask you if you want to create a new one. It will be empty though and all comments/notes would be lost. (Unless you have some database utilities and a little practice with database files but there are data recovery methods if needed for both the .DBF and .DBT files.) SAMPDISK NTX - \ SAMPBLKS NTX - \ \ SAMPQUAL NTX - / / Automatically created index files. For EPS SAMPLES NTX - // Samples. SDISK NTX -// SBLOCKS NTX -/ Hint: Choose INDEX ORDER from the Browse/Edit menu to instantly view the data resorted in a different order. Index orders --------------------- 1: SAMPDISK.NTX - Disk Number + Sample Name 2: SAMPBLKS.NTX - Sample Name + Block Size 3: SAMPQUAL.NTX - Qualities 4: SAMPLES.NTX - Sample Name 5. SDISK.NTX - Disk Number 6. SBLOCKS.NTX - Ascending Block Size SMPEDM DBF - \ SMPEDM DBT - -> Non-EPS Sample Database files. Created SMPNAME NTX - \ SMPTYPE NTX - -> Automatically created index files. SMPQUAL NTX - / for Non-EPS Sample files. BAK_DATA DBF - Backup .DBF and .DBT file used in temp operations. BAK_DATA DBT - Delete if found when not running the program. - Unless the program is not terminated normally, they will be deleted automatically. SFREPORT.DBF - List Records Report Definition files SFREPORT.NTX - Automatically created when you save definitions DC_QUERY.DBF - Saved queries are stored here HELP DBF - \ HELP DBT - \ \ REQUIRED FOR THE NEW HELP SYSTEM HELP NTX - / / RR CNF -\ \ RRUN EXE - \ \ RRUNOUT DBF - / / Report writer runtime and config files. RRUNTIME EXE -/ / SAMPLES RP1 --------> Without this, no reports!!!! Cherish it... ESD DBF --------> Report disctionary file. Automatically built. README ESD --------/ Hopefully you read this.... TYPE DBF \ TYPE NTX \ QUALITY DBF \ QUALITY NTX / Lookup table files and indexes. SOURCES DBF / SOURCES NTX / XTENSION DBF \ XTENSION NTX / - Extension files to determine what gets imported into the Non-EPS database. ===================================================================== Quick and dirty up and running: Just create directory (i.e., C:\SAMPLES) and then change to that directory, copy in the files ESDxxxx.ZIP, and unzip them (PKUNZIP *). Then delete the .ZIP files to get back the disk space. Type ESD ( For ESD.EXE) to run the program. Press F1 for help and F1 twice for the Help Index... ===================================================================== UPGRADE INFORMATION February 15, 1993 - v2.01 All lookups now show in indexed (alphabetical) ascending order after new records have been added to them. When using the lookups (Pressing F2 while on DATE, TYPE, QUALITIES, SOURCES) the records are now properly displayed in alpha order. Hint: To find a something in a lookup, besides using the up and down arrow keys, you can also just type the first letter of what you are trying to locate in the lookup. You can then just press ENTER to go to the first that match, or keep typing in additional parts of the record you wish to find. To maintain data integrity, when entering TYPE, QUALTITIES and SOURCES and you can now leave them blank. However, if you enter something into the field, it has to be something that exists in the correspoding lookup table. If not, a warning message will pop-up explaining that the data you entered was "Not a Valid Entry-Not Found in Lookup Table". If you want to go ahead an enter your new value into one of the fields with lookups, you must make sure that it has been added to the lookup tables. Fixed the jumping of the cursor after returning from FILE PACK or OTHER MENU items. The cursor now properly remains on the last menu item choosen. Updated some of the help screens for more info and fixed a few errors in the help info. Was a nice guy and got rid of the opening "greeting message" screen so you go right into the program. For now removed the GO TOP and GO BOTTOM "OTHER MENU" options. There was a problem with the screen redraw and I don't have time to fix it right now. To quickly navigate the file (other than using NEXT RECORD, PREVIOUS RECORD or KEY SEARCH: Choose TABLEVIEW and then use the up and down arrows or CTRL-PGDN to go to the bottom of the file or CTRL-PGUP to go to the top of the file. ===================================================================== February 15, 1993 - v2.0 New Browse / Edit system. Not as many features as the previous one but seems to work well and probably easier for those less experienced with any type of database. When printing the 'canned' reports you now have the option to set an additional filter for that print job as well as it will now preview to the screen before printing if you want. You can then scroll it, pan it, window it or more or print it out. Some other bug fixes and changes including the label printing function for EPS disks. I have tested it quite extensively and it hasn't failed me yet. Probably just lucky on my part so far. So let me know. ------------------------------------------------------------------- Before going any further, BACKUP your existing DATA Files if you want to keep what you have. (All *.DBF, *.NTX and *.DBT. You can also delete the HELPFILE.* files as the new help files are named HELP.*). To upgrade, copy all of the files in these 2 .ZIP's into a new directory than copy all *.DBF/*.DBT/*.NTX files from the old directory into the new one (and delete HELPFILE.* not HELP.*). All file structures are the same so nothing will change. If you haven't already modified your lookup files, or you were using a version that did not use them, I have included a new copy with default types, qualities and sources: TYPES.* QUALITY.* SOURCES.* That's all there is to it..... Use the main menu item to "Re-Index ALL files". --------------------------------------------------------------------- Note: I would recommend that you create a new sample database and feed all your disks back into it if you are upgrading. The reason is because of EDIR. It can properly distinguish between instruments, sound banks and songs and and are now properly placed in the database. --------------------------------------------------------------------- That's it... HISTORY: ===================================================================== 11/29/92 v1.2b Fixed problem when a user persisted on using the program after saying NO multiple times to create the desired files. I would force file creation but I didn't want the users existing sample and lookup files to be blown away in the event of an upgrade or damaged file. More file checking in import procedures. ESD.DBF file is now automatically created and deleted (thanks for the Suggestion Dave!) ===================================================================== 11/29/92 v1.2a New feature to read in ANY file type based on a dictionary file (XTENSION.DBF) that contains the files extension (EXT) and assigns a TYPE to it. There are 4 default types when the file is created: DIG - DIGIDESIGN EDE - Endoniq Disk Manager DISK File EFE - Ensoniq Disk Manager (EDM) Instrument File (IBM) SMP - Sample Vision You can delete, add, or change any of these. Unless the extension being imported is found in this database, it will be bypassed. To edit the XTENSION.DBF file, choose VIEW / EDIT from the Main Menu and then choose LOOKUPS and EXTENSION Tables. Added 3 reports to print the various file types in name, type, and qualities order. Fixed a few other minor bugs and chopped some fat out of a library I was using. This reduced both the .EXE size and memory requirements. Not a great deal, but every little bit helps. ===================================================================== 11/27/92 v1.1e Fixed problem where if a user pressed F2 while in Lookup Table View / Edit, "Variable not found" was displayed and dropped the user back to DOS. Changed program to enable lookups even while viewing in a filtered mode (SEARCH/SET FILTER). ===================================================================== 11/26/92 v1.1d Fixed (I think permanently) the problem with using ESD with QEMM in stealth mode. Less memory now for the DOS SHELL feature but it should me more than enough for normal use. (Make sure command.com is in the path!) Fixed problem if HELPFILE not found. Now pops up warning message. Fixed problem if trying to print from a directory other than C:\SAMPLES. Alls the user need due is delete the file ESD.DBF. This cause a new one to be created with the correct directory info. ===================================================================== 11/25/92 v1.1c I fixed (again, I think I fixed) the memory problem. Seems some computers require a larger overhead in the amount swapping out so the swap function I use can locate a place in memory for it. I thought I was giving it plenty but your pc doesn't like it unless i give it all available memory to it and let it decide where and how much it wants. If also seems that it's stealing everything QEMM can give it leaving zip for swapping. I'm working on it.... It might run a little slower unless you have a RAM drive. (SET TMP=The Ram Drive) The entire import procedure was rewritten and now checks each record being imported as to whether or not it already exists and at the same time adds the disk number sequentially based on the last disk in the main samples database. I beat it to death here seems to be working great. It takes a little longer now for the import process, but it was a necessity. I have the lookups all done and working great. I think you will really like this feature. You can enter long quality/keywords by just pressing F2, locate the desired quality, and press enter, same for type and source. Lookups work when: - You are over the TYPE, QUALITIES or SOURCE fields - You can enter additional TYPES, QUALITIES and SOURCES into the lookup tables choosing 1 followed by 3 starting from the Main Menu. (View/Edit - LOOKUP TABLES). The same keys are available for all View/Browsing and Editing areas Lookup Files: TYPE.DBF TYPE.NTX QUALITY.DBF QUALITY.NTX SOURCES.DBF SOURCES.NTX You can delete and start over if you want. When you load the program, the best thing to do is run the REINDEX procedure (Menu Item #4) and recreate these files. I also widened the SOURCE field from 15 to 25 spaces. If you have samples already in your database and don't want to lose what you have, you won't. You could do a MODIFY STRUCTURE from the util menu and change the field from 15 to 25 manually. If you let the system create a new database by deleting your old one, it will create it correctly. ++++++++++++++++++++++++++++++++++++++++++++++++====================== 11/24/92 Modifed the import routine so even if a user accidently copies the same disk twice, that disk will be bypassed and the disk number will not be incremented. ===================================================================== Hints and notes: Miscellaneous bits of helpful info. Maybe some day I'll actually write some documentation. But, in lots of cases I feel if you need docs then the program is too difficult to use. Then again, I'm lazy, that's why I wrote this thing. Most people will probably not have gotten this far! Hints or common questions answered: You could use the OTHER FILES Import procedure to import all kinds of files. To run the program, just unzip into a directory of your choice and run ESD.EXE. I have run it sucessfully under Windows using a default pif file. If possible, give it some expanded memory and more preferably a cache (around 1-2mb's does nicely). The program will not import duplicates. I determine this by taking the sample name, if I find that exists, I then check the block count, if they differ it is then imported, if both name and block size are indentical, it is bypassed. There are three canned reports. You can print the sample listings by Name, Disk Number, or Qualities. You can also specify a page range (in case it jams and you have to restart this comes in very handy) and number of copies. I only set it up for 2 basic printer types, a laser and a dot matrix (choose 1 for laser and 2 for dot). By choosing list from within the View / Edit /Query you can create your own quick little reports and print them to a file, screen or printer. You can also set a filter (SEARCH/SET FILTER) before printing and only those matching the filter will be printed. Separate database and reports for Sample Vision and EDM Format Disks DELETING RECORDS - Choose OTHER MENU from the main View/Browse menu to globally delete records. Don't forget to press F1 for help Keep in mind, because of the duplicate record purging, if you have multiple disks with something like SOUNDBANK 1 on them, all but one will be deleted. Another side note. Don't enter a new disk with the number 0 (ZERO). It will be deleted. -------------------------------------------------------------------